# -*-coding:utf8 -*-
# SQL语句
# 测试
query_all_info = '''
SELECT id,pub_time,title,company,content FROM info ORDER By id DESC;
'''

insert_into_info_word = '''
INSERT INTO info_word (article_id, pub_time, cut_content, create_date, company) VALUES ('%s', '%s', '%s', '%s', '%s');
'''

ignore_same_id = '''
SELECT COUNT(*) FROM info_word WHERE article_id = %d;

'''

query_all_info_word = '''
SELECT pub_time,cut_content FROM info_word;
'''

query_all_info_word_by_page = '''
SELECT pub_time,cut_content FROM info_word Limit %d,%d;
'''

query_info_word_counts = '''
SELECT COUNT(*) FROM info_word;
'''

# mysql数据库配置信息
db_config = {
    'host': '127.0.0.1',
    'user': 'root',
    'port': 3306,
    'password': '123456',
    'db': 'inter'
}

# mongodb 数据库配置信息
mongo_db_config = {
    'host': '127.0.0.1',
    'port': 27017,
    'db': "intel"
}
